<html lang="zh">
 <head></head>
 <body style="text-align:center;">
  ﻿
  <title>pig_micro_ep文档</title>
  <style type="text/css">body {            padding-bottom: 50px        }        body, td {            font-family: verdana, fantasy;            font-size: 12px;            line-height: 150%        }        table {            width: 100%;            background-color: #ccc;            margin: 5px 0        }        td {            background-color: #fff;            padding: 3px 3px 3px 10px        }        thead td {            text-align: center;            font-weight: bold;            background-color: #eee        }        a:link, a:visited, a:active {            color: #015fb6;            text-decoration: none        }        a:hover {            color: #e33e06        }</style>
  <div style="width:800px; margin:20px auto; text-align:left;">
   <a name="index"></a>
   <h2 style="text-align:center; line-height:50px;">pig_micro_ep文档</h2>
   <div>
    <b>数据库名：pig_micro_ep</b>
    <br><b>文档版本：0.0.1-SNAPSHOT</b>
    <br><b>文档描述：pig_micro_ep文档生成</b>
    <br>
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>表名</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td><a href="#ac_mep_rider_company_info">ac_mep_rider_company_info</a></td>
      <td>骑士-众包公司表</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td><a href="#ac_mep_rider_ext">ac_mep_rider_ext</a></td>
      <td>骑士扩展表</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td><a href="#ac_mep_rider_info">ac_mep_rider_info</a></td>
      <td>微企-骑士账号表</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td><a href="#ac_mep_user_ext_info">ac_mep_user_ext_info</a></td>
      <td>微企帐号表：保存频繁更新的扩展信息，如最后登录时间。</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td><a href="#ac_mep_user_info">ac_mep_user_info</a></td>
      <td>微企帐号表</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td><a href="#od_mep_order_delivery">od_mep_order_delivery</a></td>
      <td>配送订单表</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td><a href="#od_mep_order_delivery_status_update_log">od_mep_order_delivery_status_update_log</a></td>
      <td>配送订单状态日志表</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td><a href="#od_mep_order_shipper_info">od_mep_order_shipper_info</a></td>
      <td>配送订单-发货人信息表</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td><a href="#pay_mep_payment">pay_mep_payment</a></td>
      <td>微企支付单表</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td><a href="#pay_mep_payment_item">pay_mep_payment_item</a></td>
      <td>微企支付单明细表</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td><a href="#settle_mep_account">settle_mep_account</a></td>
      <td>微企账户表</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td><a href="#settle_mep_account_detail">settle_mep_account_detail</a></td>
      <td>微企账户明细表</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td><a href="#settle_mep_charge">settle_mep_charge</a></td>
      <td>微企计费表</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td><a href="#settle_mep_charge_detail">settle_mep_charge_detail</a></td>
      <td>微企计费明细表</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td><a href="#settle_mep_charge_msg">settle_mep_charge_msg</a></td>
      <td>微企计费消息表</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td><a href="#settle_mep_receipt">settle_mep_receipt</a></td>
      <td>微企收款单</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td><a href="#settle_mep_reconciliation">settle_mep_reconciliation</a></td>
      <td>微企对账表</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td><a href="#settle_mep_reconciliation_item">settle_mep_reconciliation_item</a></td>
      <td>微企对账单详情表</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td><a href="#tbl_mep_test_order">tbl_mep_test_order</a></td>
      <td>tbl_mep_test_order</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td><a href="#tbl_mep_test_user">tbl_mep_test_user</a></td>
      <td>tbl_mep_test_user</td>
     </tr>
    </tbody>
   </table><a name="ac_mep_rider_company_info"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：ac_mep_rider_company_info</b>
   </div>
   <div>
    说明：骑士-众包公司表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>rc_license_no</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-营业执照编号</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>rc_name</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>rc_legal_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-法人姓名</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>rc_register_addr</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-注册地址</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>rc_email</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-邮箱</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>rc_license_img</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-营业执照图片URL</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>rc_agreement_img</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">众包公司-协议链接</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>modify_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">修改人</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>gmt_modified</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>create_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">创建人</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
    </tbody>
   </table><a name="ac_mep_rider_ext"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：ac_mep_rider_ext</b>
   </div>
   <div>
    说明：骑士扩展表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>rider_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">骑士ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>work_status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">工作状态(开工:START；收工:END；)</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>send_order_count</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">统计总的派单数量(系统推送到方式向骑士展示过的订单数量)</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>receive_order_count</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">统计总的接单数量(骑士的已接订单的数量，包含取消订单)</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>last_login_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后登录时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
    </tbody>
   </table><a name="ac_mep_rider_info"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：ac_mep_rider_info</b>
   </div>
   <div>
    说明：微企-骑士账号表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>nickname</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">昵称/姓名</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>tel</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">手机号码</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>login_pwd</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">登录密码</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>head_url</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">http://test-lazypig.lazipig.cn/4wBiXxHcokzWikQpa53E9TYlhTnIaySX.png</td>
      <td align="center">头像</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>email</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">邮箱</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>level_value</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">1</td>
      <td align="center">骑士等级：枚举，1倔强青铜，2秩序白银，3荣耀黄金，4尊贵铂金，5永恒钻石</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>operation_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">318</td>
      <td align="center">所属运营中心id，取值为ac_operation_company_info主键id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>province_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">服务省份id</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>city_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">服务城市id</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">状态(启用ENABLE；禁用:DISABLE；)</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>company_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">众包公司id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>referrer_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">写死0，代表自然流量；</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>referrer_role</td>
      <td align="center">varchar</td>
      <td align="center">16</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">写死空，代表自然流量</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>modify_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">修改人</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>gmt_modified</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>create_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">创建人</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
    </tbody>
   </table><a name="ac_mep_user_ext_info"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：ac_mep_user_ext_info</b>
   </div>
   <div>
    说明：微企帐号表：保存频繁更新的扩展信息，如最后登录时间。
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center"></td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">用户账户id,取值为ac_mep_user_info主键id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>last_login_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后登录时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>modify_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">修改人</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>gmt_modified</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>create_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">创建人</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
    </tbody>
   </table><a name="ac_mep_user_info"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：ac_mep_user_info</b>
   </div>
   <div>
    说明：微企帐号表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键ID</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>tel</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">手机号（登录账号）</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>login_pwd</td>
      <td align="center">varchar</td>
      <td align="center">50</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">登录密码</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>avatar</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">头像</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>nickname</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">昵称/姓名</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>ep_license_no</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">企业营业执照编号</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>ep_name</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">企业名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>ep_legal_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">企业法人姓名</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>ep_register_addr</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">企业注册地址</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>email</td>
      <td align="center">varchar</td>
      <td align="center">100</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">电子邮箱</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>ep_license_img</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">企业营业执照图片URL</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>ep_door_img</td>
      <td align="center">varchar</td>
      <td align="center">255</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">门头照</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>agreement_img</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">协议图片</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">ENABLE</td>
      <td align="center">状态（正常 ENABLE；禁用 DISABLE；）</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>ep_delivery_fee_rule_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">1</td>
      <td align="center">企业配送费模板ID，库pig_biz表rd_enterprise_delivery_fee_rule的ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>user_type</td>
      <td align="center">varchar</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">MICRO_EP</td>
      <td align="center">枚举：MICRO_EP，不可扩展</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">500</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>modify_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">修改人</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>gmt_modified</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td>create_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">创建人</td>
     </tr>
     <tr>
      <td style="text-align:center;">21</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">22</td>
      <td>is_delete</td>
      <td align="center">tinyint</td>
      <td align="center">4</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">是否删除（0不删，1已删）</td>
     </tr>
    </tbody>
   </table><a name="od_mep_order_delivery"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：od_mep_order_delivery</b>
   </div>
   <div>
    说明：配送订单表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">类型枚举：LZBWS-帮我送，LZBWQ-帮我取，LZBWM-帮我买</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>rider_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">骑士id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>rider_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">骑士名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>rider_phone</td>
      <td align="center">varchar</td>
      <td align="center">16</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">骑士注册手机号</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发单用户id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>user_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发单用户用户名</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>weight</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">总重量，数值代表千克，0表示小于1千克</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">配送单状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>memo</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>goods_category</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">物品品类</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>is_delay</td>
      <td align="center">tinyint</td>
      <td align="center">4</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">是否超时：0-否，1-是</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>receive_code</td>
      <td align="center">varchar</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">配送单收件码</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>pick_up_code</td>
      <td align="center">varchar</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">配送单取件码</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>op_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">318</td>
      <td align="center">骑士运营公司ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>op_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">平台运营公司</td>
      <td align="center">骑士运营公司名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>pay_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">用户实际支付总金额，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>delivery_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">用户实际支付的配送费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>baseAmount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">基础运费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td>weight_surcharge</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">重量附加费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">21</td>
      <td>time_surcharge</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">时段附加费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">22</td>
      <td>goods_price</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">物品价值</td>
     </tr>
     <tr>
      <td style="text-align:center;">23</td>
      <td>pay_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付成功后支付返回的id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">24</td>
      <td>pay_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">余额支付</td>
      <td align="center">支付方式</td>
     </tr>
     <tr>
      <td style="text-align:center;">25</td>
      <td>pay_access_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">企业账户</td>
      <td align="center">支付通道</td>
     </tr>
     <tr>
      <td style="text-align:center;">26</td>
      <td>coupon_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">优惠券抵扣金额，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">27</td>
      <td>shipper_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">28</td>
      <td>shipper_phone</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人联系方式</td>
     </tr>
     <tr>
      <td style="text-align:center;">29</td>
      <td>shipper_addr</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人详细地址</td>
     </tr>
     <tr>
      <td style="text-align:center;">30</td>
      <td>shipper_addr_no</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人地址门牌号</td>
     </tr>
     <tr>
      <td style="text-align:center;">31</td>
      <td>shipper_longitude</td>
      <td align="center">decimal</td>
      <td align="center">11</td>
      <td align="center">6</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人经度</td>
     </tr>
     <tr>
      <td style="text-align:center;">32</td>
      <td>shipper_latitude</td>
      <td align="center">decimal</td>
      <td align="center">11</td>
      <td align="center">6</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人纬度</td>
     </tr>
     <tr>
      <td style="text-align:center;">33</td>
      <td>consignee_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">34</td>
      <td>consignee_phone</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人联系方式</td>
     </tr>
     <tr>
      <td style="text-align:center;">35</td>
      <td>consignee_addr</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人详细地址</td>
     </tr>
     <tr>
      <td style="text-align:center;">36</td>
      <td>consignee_addr_no</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人地址门牌号</td>
     </tr>
     <tr>
      <td style="text-align:center;">37</td>
      <td>consignee_longitude</td>
      <td align="center">decimal</td>
      <td align="center">11</td>
      <td align="center">6</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人经度</td>
     </tr>
     <tr>
      <td style="text-align:center;">38</td>
      <td>consignee_latitude</td>
      <td align="center">decimal</td>
      <td align="center">11</td>
      <td align="center">6</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收货人纬度</td>
     </tr>
     <tr>
      <td style="text-align:center;">39</td>
      <td>to_consignee_distance</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发件人到收货人的距离，单位米</td>
     </tr>
     <tr>
      <td style="text-align:center;">40</td>
      <td>expected_arrive_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">预计送达时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">41</td>
      <td>actual_publish_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际发单时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">42</td>
      <td>actual_pay_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">用户实际支付完成时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">43</td>
      <td>actual_accept_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际接单时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">44</td>
      <td>actual_to_shipper_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际到发件地址时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">45</td>
      <td>actual_pick_up_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际取件时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">46</td>
      <td>actual_deliver_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际送达时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">47</td>
      <td>actual_finish_time</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">实际完成时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">48</td>
      <td>is_delete</td>
      <td align="center">tinyint</td>
      <td align="center">4</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">是否逻辑删除：0-否，1-是</td>
     </tr>
     <tr>
      <td style="text-align:center;">49</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">50</td>
      <td>gmt_modify</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
    </tbody>
   </table><a name="od_mep_order_delivery_status_update_log"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：od_mep_order_delivery_status_update_log</b>
   </div>
   <div>
    说明：配送订单状态日志表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>delivery_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">配送单ID，对应od_mep_order_delivery表的ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>rider_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">骑手ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>delivery_status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">配送单变更状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>create_user_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">创建记录的用户名</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
    </tbody>
   </table><a name="od_mep_order_shipper_info"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：od_mep_order_shipper_info</b>
   </div>
   <div>
    说明：配送订单-发货人信息表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>serial_no</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">序号</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>gener_order_nums</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">生成单数</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>shipper_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人姓名</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>shipper_phone</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货人联系方式</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>shipper_address</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货地址</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>shipper_addr_no</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货地-门牌号</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>shipper_city_name</td>
      <td align="center">varchar</td>
      <td align="center">256</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">发货地（地级市）城市名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>status</td>
      <td align="center">tinyint</td>
      <td align="center">4</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">状态：0未处理；1处理中；2已完成</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>gmt_create</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>gmt_modify</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>csv_qiniu_url</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">生成后-七牛下载地址</td>
     </tr>
    </tbody>
   </table><a name="pay_mep_payment"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：pay_mep_payment</b>
   </div>
   <div>
    说明：微企支付单表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">内部支付单号</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>pay_group_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付组id(用于合并支付)；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>combine_pay_flag</td>
      <td align="center">tinyint</td>
      <td align="center">4</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">合并支付标识</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>out_pay_id</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">第三方支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>out_prepay_id</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">第三方预支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>buyer_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>buyer_name</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>buyer_phone</td>
      <td align="center">varchar</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家手机号</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>buyer_openid</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家openid</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>device</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">终端设备id</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>device_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">终端设备类型(ANDROID;IOS)</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>app_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">APP类型(服务商APP;用户APP)</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>access_app_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">应用id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>client_ip</td>
      <td align="center">varchar</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">客户端IP</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>title</td>
      <td align="center">varchar</td>
      <td align="center">255</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付标题</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>total_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付总金额，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>charge_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付手续费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>charge_rate</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付费率</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>virtual_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">虚拟币金额(秀豆,集豆等)</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td>virtual_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">虚拟币类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">21</td>
      <td>pay_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付类型(线上支付-支付;线上支付-预支付;线下支付-现金)</td>
     </tr>
     <tr>
      <td style="text-align:center;">22</td>
      <td>source_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付来源类型:APP,H5,JSAPI,WEB</td>
     </tr>
     <tr>
      <td style="text-align:center;">23</td>
      <td>channel_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付渠道类型(现金;余额;微信;支付宝)</td>
     </tr>
     <tr>
      <td style="text-align:center;">24</td>
      <td>access_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付通道类型(微信;支付宝;中联信)</td>
     </tr>
     <tr>
      <td style="text-align:center;">25</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付单状态(初始化;待支付;支付中;已支付;支付结束;已关闭)</td>
     </tr>
     <tr>
      <td style="text-align:center;">26</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">27</td>
      <td>pay_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">28</td>
      <td>pay_finish_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付完成时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">29</td>
      <td>source_description</td>
      <td align="center">varchar</td>
      <td align="center">100</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">来源描述</td>
     </tr>
     <tr>
      <td style="text-align:center;">30</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">31</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后更新时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">32</td>
      <td>gift_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">V2.0：充值赠送金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">33</td>
      <td>client_city</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">V2.0：充值城市</td>
     </tr>
    </tbody>
   </table><a name="pay_mep_payment_item"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：pay_mep_payment_item</b>
   </div>
   <div>
    说明：微企支付单明细表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>order_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单类型(购买订单;支付订单)</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>pay_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>order_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>buyer_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">买家ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>buyer_name</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>seller_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">卖家ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>seller_name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">卖家名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付总金额，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>virtual_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">虚拟币金额(秀豆,集豆等)</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>virtual_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">虚拟币类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>charge_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付手续费，单位分</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后更新时间</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_account"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_account</b>
   </div>
   <div>
    说明：微企账户表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">账户ID</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>account_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">账户类型(MONEY=资金帐户,POINTS=积分,WALLET=钱包)</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>out_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">外部用户ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>out_user_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">外部用户类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>out_user_name</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">外部账户名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>balance</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">可用余额</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>version</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">版本</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后更新时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>is_delete</td>
      <td align="center">smallint</td>
      <td align="center">6</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">0正常,1删除</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_account_detail"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_account_detail</b>
   </div>
   <div>
    说明：微企账户明细表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">ID唯一</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>out_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">外部用户ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>out_user_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">外部用户类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>account_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">账户ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>account_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">帐户名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>account_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">账户类型(MONEY=资金帐户,POINTS=积分,WALLET=钱包)</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>change_balance</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">变动金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>remain_balance</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">当前余额</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>loan_type</td>
      <td align="center">varchar</td>
      <td align="center">15</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收支类型:收入INCOME/支出EXPEND</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>change_type</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">应用自定义变动类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>change_reason</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">变动原因</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>trans_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交易类型:RECHARGE=充值,CONSUMPTION=消费,REFUND=退款</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>sort_order</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">排序字段，降序排序，跟时间一样，越早越小</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>trans_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">交易时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>trans_acc_no</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交易帐号</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单类型(DELIVERY_ORDER=配送订单,AGENT_VAS_SERVICE_ORDER=经纪人增值服务订单,DELIVERY_TIPS=配送小费订单,RECHARGE_ORDER=充值订单,RECEIPT_ORDER=收款订单)</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>order_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>sub_order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">子订单类型:配送订单-BWS,BWM,BWQ</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>pay_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td>pay_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付单号</td>
     </tr>
     <tr>
      <td style="text-align:center;">21</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">22</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">23</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后更新时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">24</td>
      <td>is_delete</td>
      <td align="center">smallint</td>
      <td align="center">6</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">0正常,1删除</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_charge"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_charge</b>
   </div>
   <div>
    说明：微企计费表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>target_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">分账对象id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>target_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">分账对象类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>target_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">分账对象名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>total_fee</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">总金额(收入-支出)</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>sub_order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">子订单类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>order_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>pay_type</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>pay_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>pay_rate</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付费率</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>order_status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>order_amount</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单实付价格</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>order_finish_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center"></td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>gmt_modified</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">记录更新时间</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_charge_detail"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_charge_detail</b>
   </div>
   <div>
    说明：微企计费明细表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>mep_charge_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">计费ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>cost_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用类型(INCOME收入EXPEND支出)</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>cost_code</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用编码</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>cost_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">金额(分)</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>gmt_modified</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">记录更新时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>pay_target_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用支出方对象类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>gain_target_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用收入方对象类型</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_charge_msg"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_charge_msg</b>
   </div>
   <div>
    说明：微企计费消息表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">id</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>order_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>buyer_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">买家Id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>buyer_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">买家名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>rider_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">骑士Id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>rider_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">骑士名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>sub_order_type</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">子订单类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>pay_type</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">支付类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>pay_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付单号；</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>pay_rate</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">支付费率</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>order_status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>order_amount</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>order_pay_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">订单支付时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>order_finish_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">订单完成时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">状态:初始化，处理中，处理成功，处理失败</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>gmt_modified</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">记录更新时间</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_receipt"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_receipt</b>
   </div>
   <div>
    说明：微企收款单
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">收款单号(主键)</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>new_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">新建收款单用户id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>complete_user_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">确认收款单用户id；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>receive_total_amount</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">收款金额（单位：元）</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>receive_company_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">收款单位；</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>receive_company_name</td>
      <td align="center">varchar</td>
      <td align="center">200</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收款企业名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>receive_date</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">收款日期</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>confirm_receive_date</td>
      <td align="center">datetime</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">确认收款日期</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">50</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款状态 INIT：新建收款单，DOWN：已收款</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>pay_total_amount</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">交款金额（单位：元）</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>pay_company_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">交款单位id ac_user_info 主键；</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>pay_mobile</td>
      <td align="center">varchar</td>
      <td align="center">50</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款账号</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>pay_company_name</td>
      <td align="center">varchar</td>
      <td align="center">200</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款单位</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>pay_user</td>
      <td align="center">varchar</td>
      <td align="center">100</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款人(录入的中文)</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>pay_method</td>
      <td align="center">varchar</td>
      <td align="center">30</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款方式</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>business_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">业务类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>pay_content</td>
      <td align="center">varchar</td>
      <td align="center">310</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">交款内容</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>annex_url</td>
      <td align="center">varchar</td>
      <td align="center">255</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">附件内容</td>
     </tr>
     <tr>
      <td style="text-align:center;">19</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">20</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">最后更新时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">21</td>
      <td>is_delete</td>
      <td align="center">smallint</td>
      <td align="center">6</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">0正常,1删除</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_reconciliation"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_reconciliation</b>
   </div>
   <div>
    说明：微企对账表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>target_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">往来单位ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>target_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">往来单位类型:MICRO_EP=微企,OPERATION=运营公司,ENTERPRISE=企业</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>target_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">往来单位名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账单创建状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>verify_status</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">审核状态</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>items_num</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账详单数量</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>start_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">开始时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>end_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">结束时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>rec_time</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账周期</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>settle_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>pay_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账单支付时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>url</td>
      <td align="center">varchar</td>
      <td align="center">512</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">下载链接</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>op_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">MANUAL</td>
      <td align="center">自动=AUTO,手动=MANUAL</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>remark</td>
      <td align="center">varchar</td>
      <td align="center">1024</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">备注</td>
     </tr>
     <tr>
      <td style="text-align:center;">16</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">17</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">18</td>
      <td>is_delete</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">逻辑删</td>
     </tr>
    </tbody>
   </table><a name="settle_mep_reconciliation_item"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：settle_mep_reconciliation_item</b>
   </div>
   <div>
    说明：微企对账单详情表
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">主键</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>reconciliation_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">对账单ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>order_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">订单ID；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>order_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">5</td>
      <td>order_pay_time</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单支付时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">6</td>
      <td>order_pay_user</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单支付用户</td>
     </tr>
     <tr>
      <td style="text-align:center;">7</td>
      <td>order_pay_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">订单支付类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">8</td>
      <td>cost_type</td>
      <td align="center">varchar</td>
      <td align="center">32</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用类型</td>
     </tr>
     <tr>
      <td style="text-align:center;">9</td>
      <td>cost_code</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用编码</td>
     </tr>
     <tr>
      <td style="text-align:center;">10</td>
      <td>cost_name</td>
      <td align="center">varchar</td>
      <td align="center">128</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">费用名称</td>
     </tr>
     <tr>
      <td style="text-align:center;">11</td>
      <td>amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">12</td>
      <td>service_amount</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">0</td>
      <td align="center">服务费金额</td>
     </tr>
     <tr>
      <td style="text-align:center;">13</td>
      <td>gmt_create</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">创建时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">14</td>
      <td>gmt_modify</td>
      <td align="center">timestamp</td>
      <td align="center">19</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center">CURRENT_TIMESTAMP(3)</td>
      <td align="center">修改时间</td>
     </tr>
     <tr>
      <td style="text-align:center;">15</td>
      <td>is_delete</td>
      <td align="center">int</td>
      <td align="center">10</td>
      <td align="center">0</td>
      <td align="center">Y</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">逻辑删</td>
     </tr>
    </tbody>
   </table><a name="tbl_mep_test_order"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：tbl_mep_test_order</b>
   </div>
   <div>
    说明：
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">ID</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>buyer_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">；</td>
     </tr>
     <tr>
      <td style="text-align:center;">3</td>
      <td>seller_id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center">；</td>
     </tr>
     <tr>
      <td style="text-align:center;">4</td>
      <td>pay_price</td>
      <td align="center">double</td>
      <td align="center">11</td>
      <td align="center">2</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center"></td>
     </tr>
    </tbody>
   </table><a name="tbl_mep_test_user"></a>
   <div style="margin-top:30px;" class="table_name">
    <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：tbl_mep_test_user</b>
   </div>
   <div>
    说明：
   </div>
   <div>
    数据列：
   </div>
   <table cellspacing="1">
    <thead>
     <tr>
      <td style="width:40px; ">序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td style="text-align:center;">1</td>
      <td>id</td>
      <td align="center">bigint</td>
      <td align="center">20</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">Y</td>
      <td align="center"></td>
      <td align="center">ID</td>
     </tr>
     <tr>
      <td style="text-align:center;">2</td>
      <td>name</td>
      <td align="center">varchar</td>
      <td align="center">64</td>
      <td align="center">0</td>
      <td align="center">N</td>
      <td align="center">N</td>
      <td align="center"></td>
      <td align="center"></td>
     </tr>
    </tbody>
   </table>
  </div>
  <footer></footer>
 </body>
</html>
